﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="UMdataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Data Source=DEVSTUDIO\DEVSQL;Initial Catalog=DBTims;Integrated Security=True" IsAppSettingsProperty="false" Modifier="Assembly" Name="devstudio\devsql.DBTims.dbo" ParameterPrefix="@" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dtCityTableAdapter" GeneratorDataComponentClassName="dtCityTableAdapter" Name="dtCity" UserDataComponentName="dtCityTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.dtCity" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dtCity] WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dtCity] ([hName], [mgrid], [hrclvl], [hrccrt]) VALUES (@hName, @mgrid, @hrclvl, @hrccrt);
SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dtCity WHERE (CodeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dbo.dtCity</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dtCity] SET [hName] = @hName, [mgrid] = @mgrid, [hrclvl] = @hrclvl, [hrccrt] = @hrccrt WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)));
SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dtCity WHERE (CodeID = @CodeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodeID" ColumnName="CodeID" DataSourceName="DBTims.dbo.dtCity" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CodeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodeID" DataSetColumn="CodeID" />
              <Mapping SourceColumn="hName" DataSetColumn="hName" />
              <Mapping SourceColumn="mgrid" DataSetColumn="mgrid" />
              <Mapping SourceColumn="hrclvl" DataSetColumn="hrclvl" />
              <Mapping SourceColumn="hrccrt" DataSetColumn="hrccrt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dtDepTableAdapter" GeneratorDataComponentClassName="dtDepTableAdapter" Name="dtDep" UserDataComponentName="dtDepTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.dtDep" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dtDep] WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dtDep] ([hName], [mgrid], [hrclvl], [hrccrt]) VALUES (@hName, @mgrid, @hrclvl, @hrccrt);
SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dtDep WHERE (CodeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CodeID, hName, mgrid, hrclvl, hrccrt
FROM            dtDep</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dtDep] SET [hName] = @hName, [mgrid] = @mgrid, [hrclvl] = @hrclvl, [hrccrt] = @hrccrt WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)));
SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dtDep WHERE (CodeID = @CodeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodeID" ColumnName="CodeID" DataSourceName="DBTims.dbo.dtDep" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CodeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodeID" DataSetColumn="CodeID" />
              <Mapping SourceColumn="hName" DataSetColumn="hName" />
              <Mapping SourceColumn="mgrid" DataSetColumn="mgrid" />
              <Mapping SourceColumn="hrclvl" DataSetColumn="hrclvl" />
              <Mapping SourceColumn="hrccrt" DataSetColumn="hrccrt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dtPostTableAdapter" GeneratorDataComponentClassName="dtPostTableAdapter" Name="dtPost" UserDataComponentName="dtPostTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.dtPost" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[dtPost] WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[dtPost] ([hName], [mgrid], [hrclvl], [hrccrt]) VALUES (@hName, @mgrid, @hrclvl, @hrccrt);
SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dtPost WHERE (CodeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dbo.dtPost</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[dtPost] SET [hName] = @hName, [mgrid] = @mgrid, [hrclvl] = @hrclvl, [hrccrt] = @hrccrt WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)));
SELECT CodeID, hName, mgrid, hrclvl, hrccrt FROM dtPost WHERE (CodeID = @CodeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodeID" ColumnName="CodeID" DataSourceName="DBTims.dbo.dtPost" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CodeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodeID" DataSetColumn="CodeID" />
              <Mapping SourceColumn="hName" DataSetColumn="hName" />
              <Mapping SourceColumn="mgrid" DataSetColumn="mgrid" />
              <Mapping SourceColumn="hrclvl" DataSetColumn="hrclvl" />
              <Mapping SourceColumn="hrccrt" DataSetColumn="hrccrt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stAccessTableAdapter" GeneratorDataComponentClassName="stAccessTableAdapter" Name="stAccess" UserDataComponentName="stAccessTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stAccess" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stAccess] WHERE (([AccessID] = @Original_AccessID) AND ([URolesID] = @Original_URolesID) AND ([ActionsID] = @Original_ActionsID) AND ((@IsNull_AccessValue = 1 AND [AccessValue] IS NULL) OR ([AccessValue] = @Original_AccessValue)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccessID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccessID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccessValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccessValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_AccessValue" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stAccess] ([URolesID], [ActionsID], [AccessValue]) VALUES (@URolesID, @ActionsID, @AccessValue);
SELECT AccessID, URolesID, ActionsID, AccessValue FROM stAccess WHERE (AccessID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AccessValue" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT AccessID, URolesID, ActionsID, AccessValue FROM dbo.stAccess</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stAccess] SET [URolesID] = @URolesID, [ActionsID] = @ActionsID, [AccessValue] = @AccessValue WHERE (([AccessID] = @Original_AccessID) AND ([URolesID] = @Original_URolesID) AND ([ActionsID] = @Original_ActionsID) AND ((@IsNull_AccessValue = 1 AND [AccessValue] IS NULL) OR ([AccessValue] = @Original_AccessValue)));
SELECT AccessID, URolesID, ActionsID, AccessValue FROM stAccess WHERE (AccessID = @AccessID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@AccessValue" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessValue" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_AccessID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccessID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AccessValue" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AccessValue" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_AccessValue" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="AccessValue" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="AccessID" ColumnName="AccessID" DataSourceName="DBTims.dbo.stAccess" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@AccessID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="AccessID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="AccessID" DataSetColumn="AccessID" />
              <Mapping SourceColumn="URolesID" DataSetColumn="URolesID" />
              <Mapping SourceColumn="ActionsID" DataSetColumn="ActionsID" />
              <Mapping SourceColumn="AccessValue" DataSetColumn="AccessValue" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stActionsTableAdapter" GeneratorDataComponentClassName="stActionsTableAdapter" Name="stActions" UserDataComponentName="stActionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stActions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [stActions] WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)) AND ((@IsNull_hCode = 1 AND [hCode] IS NULL) OR ([hCode] = @Original_hCode)) AND ((@IsNull_hccrt = 1 AND [hccrt] IS NULL) OR ([hccrt] = @Original_hccrt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [stActions] ([hName], [mgrid], [hrclvl], [hrccrt], [hCode], [hccrt]) VALUES (@hName, @mgrid, @hrclvl, @hrccrt, @hCode, @hccrt);
SELECT CodeID, hName, mgrid, hrclvl, hrccrt, hCode, hccrt FROM stActions WHERE (CodeID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CodeID, hName, mgrid, hrclvl, hrccrt, hCode, hccrt
FROM            stActions</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [stActions] SET [hName] = @hName, [mgrid] = @mgrid, [hrclvl] = @hrclvl, [hrccrt] = @hrccrt, [hCode] = @hCode, [hccrt] = @hccrt WHERE (([CodeID] = @Original_CodeID) AND ((@IsNull_hName = 1 AND [hName] IS NULL) OR ([hName] = @Original_hName)) AND ((@IsNull_mgrid = 1 AND [mgrid] IS NULL) OR ([mgrid] = @Original_mgrid)) AND ((@IsNull_hrclvl = 1 AND [hrclvl] IS NULL) OR ([hrclvl] = @Original_hrclvl)) AND ((@IsNull_hrccrt = 1 AND [hrccrt] IS NULL) OR ([hrccrt] = @Original_hrccrt)) AND ((@IsNull_hCode = 1 AND [hCode] IS NULL) OR ([hCode] = @Original_hCode)) AND ((@IsNull_hccrt = 1 AND [hccrt] IS NULL) OR ([hccrt] = @Original_hccrt)));
SELECT CodeID, hName, mgrid, hrclvl, hrccrt, hCode, hccrt FROM stActions WHERE (CodeID = @CodeID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hCode" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@hccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hccrt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_hName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="hName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_mgrid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="mgrid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrclvl" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_hrclvl" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="hrclvl" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hrccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hrccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hrccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hCode" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hCode" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hCode" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hCode" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_hccrt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="hccrt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_hccrt" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="hccrt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="CodeID" ColumnName="CodeID" DataSourceName="DBTims.dbo.stActions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CodeID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodeID" DataSetColumn="CodeID" />
              <Mapping SourceColumn="hName" DataSetColumn="hName" />
              <Mapping SourceColumn="mgrid" DataSetColumn="mgrid" />
              <Mapping SourceColumn="hrclvl" DataSetColumn="hrclvl" />
              <Mapping SourceColumn="hrccrt" DataSetColumn="hrccrt" />
              <Mapping SourceColumn="hCode" DataSetColumn="hCode" />
              <Mapping SourceColumn="hccrt" DataSetColumn="hccrt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stRolesTableAdapter" GeneratorDataComponentClassName="stRolesTableAdapter" Name="stRoles" UserDataComponentName="stRolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stRoles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stRoles] WHERE (([RolesID] = @Original_RolesID) AND ((@IsNull_RolesN = 1 AND [RolesN] IS NULL) OR ([RolesN] = @Original_RolesN)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RolesN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RolesN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RolesN" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stRoles] ([RolesN]) VALUES (@RolesN);
SELECT RolesID, RolesN FROM stRoles WHERE (RolesID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RolesN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RolesN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT RolesID, RolesN FROM dbo.stRoles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stRoles] SET [RolesN] = @RolesN WHERE (([RolesID] = @Original_RolesID) AND ((@IsNull_RolesN = 1 AND [RolesN] IS NULL) OR ([RolesN] = @Original_RolesN)));
SELECT RolesID, RolesN FROM stRoles WHERE (RolesID = @RolesID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@RolesN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RolesN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RolesN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_RolesN" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="RolesN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="RolesID" ColumnName="RolesID" DataSourceName="DBTims.dbo.stRoles" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RolesID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="RolesID" DataSetColumn="RolesID" />
              <Mapping SourceColumn="RolesN" DataSetColumn="RolesN" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stURolesTableAdapter" GeneratorDataComponentClassName="stURolesTableAdapter" Name="stURoles" UserDataComponentName="stURolesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stURoles" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stURoles] WHERE (([URolesID] = @Original_URolesID) AND ([RolesID] = @Original_RolesID) AND ([UserID] = @Original_UserID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stURoles] ([RolesID], [UserID]) VALUES (@RolesID, @UserID);
SELECT URolesID, RolesID, UserID FROM stURoles WHERE (URolesID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT URolesID, RolesID, UserID FROM dbo.stURoles</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stURoles] SET [RolesID] = @RolesID, [UserID] = @UserID WHERE (([URolesID] = @Original_URolesID) AND ([RolesID] = @Original_RolesID) AND ([UserID] = @Original_UserID));
SELECT URolesID, RolesID, UserID FROM stURoles WHERE (URolesID = @URolesID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="URolesID" ColumnName="URolesID" DataSourceName="DBTims.dbo.stURoles" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@URolesID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="URolesID" DataSetColumn="URolesID" />
              <Mapping SourceColumn="RolesID" DataSetColumn="RolesID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stUROperTableAdapter" GeneratorDataComponentClassName="stUROperTableAdapter" Name="stUROper" UserDataComponentName="stUROperTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stUROper" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stUROper] WHERE (([UROperID] = @Original_UROperID) AND ([URolesID] = @Original_URolesID) AND ([OperID] = @Original_OperID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UROperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UROperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stUROper] ([UROperID], [URolesID], [OperID]) VALUES (@UROperID, @URolesID, @OperID);
SELECT UROperID, URolesID, OperID FROM stUROper WHERE (UROperID = @UROperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UROperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UROperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UROperID, URolesID, OperID FROM dbo.stUROper</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stUROper] SET [UROperID] = @UROperID, [URolesID] = @URolesID, [OperID] = @OperID WHERE (([UROperID] = @Original_UROperID) AND ([URolesID] = @Original_URolesID) AND ([OperID] = @Original_OperID));
SELECT UROperID, URolesID, OperID FROM stUROper WHERE (UROperID = @UROperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UROperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UROperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UROperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UROperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_URolesID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="URolesID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UROperID" DataSetColumn="UROperID" />
              <Mapping SourceColumn="URolesID" DataSetColumn="URolesID" />
              <Mapping SourceColumn="OperID" DataSetColumn="OperID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stUserActionsTableAdapter" GeneratorDataComponentClassName="stUserActionsTableAdapter" Name="stUserActions" UserDataComponentName="stUserActionsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stUserActions" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stUserActions] WHERE (([UserActionID] = @Original_UserActionID) AND ([UserID] = @Original_UserID) AND ([ActionsID] = @Original_ActionsID) AND ([Spend] = @Original_Spend))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserActionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stUserActions] ([UserID], [ActionsID], [Spend]) VALUES (@UserID, @ActionsID, @Spend);
SELECT UserActionID, UserID, ActionsID, Spend FROM stUserActions WHERE (UserActionID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserActionID, UserID, ActionsID, Spend FROM dbo.stUserActions</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stUserActions] SET [UserID] = @UserID, [ActionsID] = @ActionsID, [Spend] = @Spend WHERE (([UserActionID] = @Original_UserActionID) AND ([UserID] = @Original_UserID) AND ([ActionsID] = @Original_ActionsID) AND ([Spend] = @Original_Spend));
SELECT UserActionID, UserID, ActionsID, Spend FROM stUserActions WHERE (UserActionID = @UserActionID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserActionID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserActionID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ActionsID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ActionsID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserActionID" ColumnName="UserActionID" DataSourceName="DBTims.dbo.stUserActions" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserActionID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserActionID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserActionID" DataSetColumn="UserActionID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="ActionsID" DataSetColumn="ActionsID" />
              <Mapping SourceColumn="Spend" DataSetColumn="Spend" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stUserOperTableAdapter" GeneratorDataComponentClassName="stUserOperTableAdapter" Name="stUserOper" UserDataComponentName="stUserOperTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stUserOper" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[stUserOper] WHERE (([UserOperID] = @Original_UserOperID) AND ([UserID] = @Original_UserID) AND ([OperID] = @Original_OperID) AND ([Spend] = @Original_Spend))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserOperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserOperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[stUserOper] ([UserOperID], [UserID], [OperID], [Spend]) VALUES (@UserOperID, @UserID, @OperID, @Spend);
SELECT UserOperID, UserID, OperID, Spend FROM stUserOper WHERE (UserOperID = @UserOperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserOperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserOperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT UserOperID, UserID, OperID, Spend FROM dbo.stUserOper</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[stUserOper] SET [UserOperID] = @UserOperID, [UserID] = @UserID, [OperID] = @OperID, [Spend] = @Spend WHERE (([UserOperID] = @Original_UserOperID) AND ([UserID] = @Original_UserID) AND ([OperID] = @Original_OperID) AND ([Spend] = @Original_Spend));
SELECT UserOperID, UserID, OperID, Spend FROM stUserOper WHERE (UserOperID = @UserOperID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserOperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserOperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserOperID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserOperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_OperID" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="OperID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserOperID" DataSetColumn="UserOperID" />
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="OperID" DataSetColumn="OperID" />
              <Mapping SourceColumn="Spend" DataSetColumn="Spend" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="stUsersTableAdapter" GeneratorDataComponentClassName="stUsersTableAdapter" Name="stUsers" UserDataComponentName="stUsersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.stUsers" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [stUsers] WHERE (([UserID] = @Original_UserID) AND ((@IsNull_StaffID = 1 AND [StaffID] IS NULL) OR ([StaffID] = @Original_StaffID)) AND ([UserN] = @Original_UserN) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Spend] = @Original_Spend) AND ((@IsNull_DateES = 1 AND [DateES] IS NULL) OR ([DateES] = @Original_DateES)) AND ((@IsNull_DateEE = 1 AND [DateEE] IS NULL) OR ([DateEE] = @Original_DateEE)) AND ((@IsNull_DateSS = 1 AND [DateSS] IS NULL) OR ([DateSS] = @Original_DateSS)) AND ((@IsNull_DateSE = 1 AND [DateSE] IS NULL) OR ([DateSE] = @Original_DateSE)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StaffID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StaffID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateES" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateES" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateEE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateEE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateEE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateEE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateSS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateSS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateSS" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateSE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateSE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSE" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [stUsers] ([StaffID], [UserN], [Description], [Spend], [DateES], [DateEE], [DateSS], [DateSE], [Psw]) VALUES (@StaffID, @UserN, @Description, @Spend, @DateES, @DateEE, @DateSS, @DateSE, @Psw);
SELECT UserID, StaffID, UserN, Description, Spend, DateES, DateEE, DateSS, DateSE, Psw FROM stUsers WHERE (UserID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StaffID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateES" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateEE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateEE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateSS" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateSE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Psw" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Psw" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        UserID, StaffID, UserN, Description, Spend, DateES, DateEE, DateSS, DateSE, Psw
FROM            stUsers</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [stUsers] SET [StaffID] = @StaffID, [UserN] = @UserN, [Description] = @Description, [Spend] = @Spend, [DateES] = @DateES, [DateEE] = @DateEE, [DateSS] = @DateSS, [DateSE] = @DateSE, [Psw] = @Psw WHERE (([UserID] = @Original_UserID) AND ((@IsNull_StaffID = 1 AND [StaffID] IS NULL) OR ([StaffID] = @Original_StaffID)) AND ([UserN] = @Original_UserN) AND ((@IsNull_Description = 1 AND [Description] IS NULL) OR ([Description] = @Original_Description)) AND ([Spend] = @Original_Spend) AND ((@IsNull_DateES = 1 AND [DateES] IS NULL) OR ([DateES] = @Original_DateES)) AND ((@IsNull_DateEE = 1 AND [DateEE] IS NULL) OR ([DateEE] = @Original_DateEE)) AND ((@IsNull_DateSS = 1 AND [DateSS] IS NULL) OR ([DateSS] = @Original_DateSS)) AND ((@IsNull_DateSE = 1 AND [DateSE] IS NULL) OR ([DateSE] = @Original_DateSE)));
SELECT UserID, StaffID, UserN, Description, Spend, DateES, DateEE, DateSS, DateSE, Psw FROM stUsers WHERE (UserID = @UserID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StaffID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UserN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateES" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateES" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateEE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateEE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateSS" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSS" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@DateSE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSE" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@Psw" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="Psw" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_UserID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StaffID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StaffID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StaffID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UserN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UserN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Description" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Description" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Spend" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Spend" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateES" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateES" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateES" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateES" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateEE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateEE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateEE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateEE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateSS" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateSS" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateSS" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSS" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateSE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateSE" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Object" Direction="Input" ParameterName="@Original_DateSE" Precision="0" ProviderType="Variant" Scale="0" Size="0" SourceColumn="DateSE" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="UserID" ColumnName="UserID" DataSourceName="DBTims.dbo.stUsers" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@UserID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="UserID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="UserID" DataSetColumn="UserID" />
              <Mapping SourceColumn="StaffID" DataSetColumn="StaffID" />
              <Mapping SourceColumn="UserN" DataSetColumn="UserN" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="Spend" DataSetColumn="Spend" />
              <Mapping SourceColumn="DateES" DataSetColumn="DateES" />
              <Mapping SourceColumn="DateEE" DataSetColumn="DateEE" />
              <Mapping SourceColumn="DateSS" DataSetColumn="DateSS" />
              <Mapping SourceColumn="DateSE" DataSetColumn="DateSE" />
              <Mapping SourceColumn="Psw" DataSetColumn="Psw" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fn_TGetActions1TableAdapter" GeneratorDataComponentClassName="fn_TGetActions1TableAdapter" Name="fn_TGetActions1" UserDataComponentName="fn_TGetActions1TableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.fn_TGetActions1" DbObjectType="Function" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        CodeID, hName, mgrid, hrclvl, hrccrt, hCode, hccrt, isGrant
FROM            dbo.fn_TGetActions1(5) AS fn_TGetActions1_1</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CodeID" DataSetColumn="CodeID" />
              <Mapping SourceColumn="hName" DataSetColumn="hName" />
              <Mapping SourceColumn="mgrid" DataSetColumn="mgrid" />
              <Mapping SourceColumn="hrclvl" DataSetColumn="hrclvl" />
              <Mapping SourceColumn="hrccrt" DataSetColumn="hrccrt" />
              <Mapping SourceColumn="hCode" DataSetColumn="hCode" />
              <Mapping SourceColumn="hccrt" DataSetColumn="hccrt" />
              <Mapping SourceColumn="isGrant" DataSetColumn="isGrant" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="dtStaffTableAdapter" GeneratorDataComponentClassName="dtStaffTableAdapter" Name="dtStaff" UserDataComponentName="dtStaffTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="devstudio\devsql.DBTims.dbo" DbObjectName="DBTims.dbo.dtStaff" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        dtStaff.*
FROM            dtStaff</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="StaffID" DataSetColumn="StaffID" />
              <Mapping SourceColumn="DepID" DataSetColumn="DepID" />
              <Mapping SourceColumn="PostID" DataSetColumn="PostID" />
              <Mapping SourceColumn="CityID" DataSetColumn="CityID" />
              <Mapping SourceColumn="StaffName" DataSetColumn="StaffName" />
              <Mapping SourceColumn="addr" DataSetColumn="addr" />
              <Mapping SourceColumn="Gender" DataSetColumn="Gender" />
              <Mapping SourceColumn="DBorn" DataSetColumn="DBorn" />
              <Mapping SourceColumn="DWork" DataSetColumn="DWork" />
              <Mapping SourceColumn="PerNum" DataSetColumn="PerNum" />
              <Mapping SourceColumn="TabNum" DataSetColumn="TabNum" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="UMdataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="UMdataSet" msprop:Generator_DataSetName="UMdataSet" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="dtCity" msprop:Generator_UserTableName="dtCity" msprop:Generator_RowDeletedName="dtCityRowDeleted" msprop:Generator_RowChangedName="dtCityRowChanged" msprop:Generator_RowClassName="dtCityRow" msprop:Generator_RowChangingName="dtCityRowChanging" msprop:Generator_RowEvArgName="dtCityRowChangeEvent" msprop:Generator_RowEvHandlerName="dtCityRowChangeEventHandler" msprop:Generator_TableClassName="dtCityDataTable" msprop:Generator_TableVarName="tabledtCity" msprop:Generator_RowDeletingName="dtCityRowDeleting" msprop:Generator_TablePropName="dtCity">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CodeID" msprop:Generator_ColumnVarNameInTable="columnCodeID" msprop:Generator_ColumnPropNameInRow="CodeID" msprop:Generator_ColumnPropNameInTable="CodeIDColumn" type="xs:int" />
              <xs:element name="hName" msprop:Generator_UserColumnName="hName" msprop:Generator_ColumnVarNameInTable="columnhName" msprop:Generator_ColumnPropNameInRow="hName" msprop:Generator_ColumnPropNameInTable="hNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mgrid" msprop:Generator_UserColumnName="mgrid" msprop:Generator_ColumnVarNameInTable="columnmgrid" msprop:Generator_ColumnPropNameInRow="mgrid" msprop:Generator_ColumnPropNameInTable="mgridColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hrclvl" msprop:Generator_UserColumnName="hrclvl" msprop:Generator_ColumnVarNameInTable="columnhrclvl" msprop:Generator_ColumnPropNameInRow="hrclvl" msprop:Generator_ColumnPropNameInTable="hrclvlColumn" type="xs:short" minOccurs="0" />
              <xs:element name="hrccrt" msprop:Generator_UserColumnName="hrccrt" msprop:Generator_ColumnVarNameInTable="columnhrccrt" msprop:Generator_ColumnPropNameInRow="hrccrt" msprop:Generator_ColumnPropNameInTable="hrccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtDep" msprop:Generator_UserTableName="dtDep" msprop:Generator_RowDeletedName="dtDepRowDeleted" msprop:Generator_RowChangedName="dtDepRowChanged" msprop:Generator_RowClassName="dtDepRow" msprop:Generator_RowChangingName="dtDepRowChanging" msprop:Generator_RowEvArgName="dtDepRowChangeEvent" msprop:Generator_RowEvHandlerName="dtDepRowChangeEventHandler" msprop:Generator_TableClassName="dtDepDataTable" msprop:Generator_TableVarName="tabledtDep" msprop:Generator_RowDeletingName="dtDepRowDeleting" msprop:Generator_TablePropName="dtDep">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CodeID" msprop:Generator_ColumnVarNameInTable="columnCodeID" msprop:Generator_ColumnPropNameInRow="CodeID" msprop:Generator_ColumnPropNameInTable="CodeIDColumn" type="xs:int" />
              <xs:element name="hName" msprop:Generator_UserColumnName="hName" msprop:Generator_ColumnVarNameInTable="columnhName" msprop:Generator_ColumnPropNameInRow="hName" msprop:Generator_ColumnPropNameInTable="hNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mgrid" msprop:Generator_UserColumnName="mgrid" msprop:Generator_ColumnVarNameInTable="columnmgrid" msprop:Generator_ColumnPropNameInRow="mgrid" msprop:Generator_ColumnPropNameInTable="mgridColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hrclvl" msprop:Generator_UserColumnName="hrclvl" msprop:Generator_ColumnVarNameInTable="columnhrclvl" msprop:Generator_ColumnPropNameInRow="hrclvl" msprop:Generator_ColumnPropNameInTable="hrclvlColumn" type="xs:short" minOccurs="0" />
              <xs:element name="hrccrt" msprop:Generator_UserColumnName="hrccrt" msprop:Generator_ColumnVarNameInTable="columnhrccrt" msprop:Generator_ColumnPropNameInRow="hrccrt" msprop:Generator_ColumnPropNameInTable="hrccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtPost" msprop:Generator_UserTableName="dtPost" msprop:Generator_RowDeletedName="dtPostRowDeleted" msprop:Generator_RowChangedName="dtPostRowChanged" msprop:Generator_RowClassName="dtPostRow" msprop:Generator_RowChangingName="dtPostRowChanging" msprop:Generator_RowEvArgName="dtPostRowChangeEvent" msprop:Generator_RowEvHandlerName="dtPostRowChangeEventHandler" msprop:Generator_TableClassName="dtPostDataTable" msprop:Generator_TableVarName="tabledtPost" msprop:Generator_RowDeletingName="dtPostRowDeleting" msprop:Generator_TablePropName="dtPost">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CodeID" msprop:Generator_ColumnVarNameInTable="columnCodeID" msprop:Generator_ColumnPropNameInRow="CodeID" msprop:Generator_ColumnPropNameInTable="CodeIDColumn" type="xs:int" />
              <xs:element name="hName" msprop:Generator_UserColumnName="hName" msprop:Generator_ColumnVarNameInTable="columnhName" msprop:Generator_ColumnPropNameInRow="hName" msprop:Generator_ColumnPropNameInTable="hNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mgrid" msprop:Generator_UserColumnName="mgrid" msprop:Generator_ColumnVarNameInTable="columnmgrid" msprop:Generator_ColumnPropNameInRow="mgrid" msprop:Generator_ColumnPropNameInTable="mgridColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hrclvl" msprop:Generator_UserColumnName="hrclvl" msprop:Generator_ColumnVarNameInTable="columnhrclvl" msprop:Generator_ColumnPropNameInRow="hrclvl" msprop:Generator_ColumnPropNameInTable="hrclvlColumn" type="xs:short" minOccurs="0" />
              <xs:element name="hrccrt" msprop:Generator_UserColumnName="hrccrt" msprop:Generator_ColumnVarNameInTable="columnhrccrt" msprop:Generator_ColumnPropNameInRow="hrccrt" msprop:Generator_ColumnPropNameInTable="hrccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stAccess" msprop:Generator_UserTableName="stAccess" msprop:Generator_RowDeletedName="stAccessRowDeleted" msprop:Generator_RowChangedName="stAccessRowChanged" msprop:Generator_RowClassName="stAccessRow" msprop:Generator_RowChangingName="stAccessRowChanging" msprop:Generator_RowEvArgName="stAccessRowChangeEvent" msprop:Generator_RowEvHandlerName="stAccessRowChangeEventHandler" msprop:Generator_TableClassName="stAccessDataTable" msprop:Generator_TableVarName="tablestAccess" msprop:Generator_RowDeletingName="stAccessRowDeleting" msprop:Generator_TablePropName="stAccess">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="AccessID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="AccessID" msprop:Generator_ColumnVarNameInTable="columnAccessID" msprop:Generator_ColumnPropNameInRow="AccessID" msprop:Generator_ColumnPropNameInTable="AccessIDColumn" type="xs:int" />
              <xs:element name="URolesID" msprop:Generator_UserColumnName="URolesID" msprop:Generator_ColumnVarNameInTable="columnURolesID" msprop:Generator_ColumnPropNameInRow="URolesID" msprop:Generator_ColumnPropNameInTable="URolesIDColumn" type="xs:int" />
              <xs:element name="ActionsID" msprop:Generator_UserColumnName="ActionsID" msprop:Generator_ColumnVarNameInTable="columnActionsID" msprop:Generator_ColumnPropNameInRow="ActionsID" msprop:Generator_ColumnPropNameInTable="ActionsIDColumn" type="xs:int" />
              <xs:element name="AccessValue" msprop:Generator_UserColumnName="AccessValue" msprop:Generator_ColumnVarNameInTable="columnAccessValue" msprop:Generator_ColumnPropNameInRow="AccessValue" msprop:Generator_ColumnPropNameInTable="AccessValueColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stActions" msprop:Generator_UserTableName="stActions" msprop:Generator_RowDeletedName="stActionsRowDeleted" msprop:Generator_RowChangedName="stActionsRowChanged" msprop:Generator_RowClassName="stActionsRow" msprop:Generator_RowChangingName="stActionsRowChanging" msprop:Generator_RowEvArgName="stActionsRowChangeEvent" msprop:Generator_RowEvHandlerName="stActionsRowChangeEventHandler" msprop:Generator_TableClassName="stActionsDataTable" msprop:Generator_TableVarName="tablestActions" msprop:Generator_RowDeletingName="stActionsRowDeleting" msprop:Generator_TablePropName="stActions">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodeID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="CodeID" msprop:Generator_ColumnPropNameInRow="CodeID" msprop:Generator_ColumnVarNameInTable="columnCodeID" msprop:Generator_ColumnPropNameInTable="CodeIDColumn" type="xs:int" />
              <xs:element name="hName" msprop:Generator_UserColumnName="hName" msprop:Generator_ColumnPropNameInRow="hName" msprop:Generator_ColumnVarNameInTable="columnhName" msprop:Generator_ColumnPropNameInTable="hNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mgrid" msprop:Generator_UserColumnName="mgrid" msprop:Generator_ColumnPropNameInRow="mgrid" msprop:Generator_ColumnVarNameInTable="columnmgrid" msprop:Generator_ColumnPropNameInTable="mgridColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hrclvl" msprop:Generator_UserColumnName="hrclvl" msprop:Generator_ColumnPropNameInRow="hrclvl" msprop:Generator_ColumnVarNameInTable="columnhrclvl" msprop:Generator_ColumnPropNameInTable="hrclvlColumn" type="xs:short" minOccurs="0" />
              <xs:element name="hrccrt" msprop:Generator_UserColumnName="hrccrt" msprop:Generator_ColumnPropNameInRow="hrccrt" msprop:Generator_ColumnVarNameInTable="columnhrccrt" msprop:Generator_ColumnPropNameInTable="hrccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hCode" msprop:Generator_UserColumnName="hCode" msprop:Generator_ColumnPropNameInRow="hCode" msprop:Generator_ColumnVarNameInTable="columnhCode" msprop:Generator_ColumnPropNameInTable="hCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hccrt" msprop:Generator_UserColumnName="hccrt" msprop:Generator_ColumnPropNameInRow="hccrt" msprop:Generator_ColumnVarNameInTable="columnhccrt" msprop:Generator_ColumnPropNameInTable="hccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stRoles" msprop:Generator_UserTableName="stRoles" msprop:Generator_RowDeletedName="stRolesRowDeleted" msprop:Generator_RowChangedName="stRolesRowChanged" msprop:Generator_RowClassName="stRolesRow" msprop:Generator_RowChangingName="stRolesRowChanging" msprop:Generator_RowEvArgName="stRolesRowChangeEvent" msprop:Generator_RowEvHandlerName="stRolesRowChangeEventHandler" msprop:Generator_TableClassName="stRolesDataTable" msprop:Generator_TableVarName="tablestRoles" msprop:Generator_RowDeletingName="stRolesRowDeleting" msprop:Generator_TablePropName="stRoles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="RolesID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="RolesID" msprop:Generator_ColumnVarNameInTable="columnRolesID" msprop:Generator_ColumnPropNameInRow="RolesID" msprop:Generator_ColumnPropNameInTable="RolesIDColumn" type="xs:int" />
              <xs:element name="RolesN" msprop:Generator_UserColumnName="RolesN" msprop:Generator_ColumnVarNameInTable="columnRolesN" msprop:Generator_ColumnPropNameInRow="RolesN" msprop:Generator_ColumnPropNameInTable="RolesNColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stURoles" msprop:Generator_UserTableName="stURoles" msprop:Generator_RowDeletedName="stURolesRowDeleted" msprop:Generator_RowChangedName="stURolesRowChanged" msprop:Generator_RowClassName="stURolesRow" msprop:Generator_RowChangingName="stURolesRowChanging" msprop:Generator_RowEvArgName="stURolesRowChangeEvent" msprop:Generator_RowEvHandlerName="stURolesRowChangeEventHandler" msprop:Generator_TableClassName="stURolesDataTable" msprop:Generator_TableVarName="tablestURoles" msprop:Generator_RowDeletingName="stURolesRowDeleting" msprop:Generator_TablePropName="stURoles">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="URolesID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="URolesID" msprop:Generator_ColumnVarNameInTable="columnURolesID" msprop:Generator_ColumnPropNameInRow="URolesID" msprop:Generator_ColumnPropNameInTable="URolesIDColumn" type="xs:int" />
              <xs:element name="RolesID" msprop:Generator_UserColumnName="RolesID" msprop:Generator_ColumnVarNameInTable="columnRolesID" msprop:Generator_ColumnPropNameInRow="RolesID" msprop:Generator_ColumnPropNameInTable="RolesIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stUROper" msprop:Generator_UserTableName="stUROper" msprop:Generator_RowDeletedName="stUROperRowDeleted" msprop:Generator_RowChangedName="stUROperRowChanged" msprop:Generator_RowClassName="stUROperRow" msprop:Generator_RowChangingName="stUROperRowChanging" msprop:Generator_RowEvArgName="stUROperRowChangeEvent" msprop:Generator_RowEvHandlerName="stUROperRowChangeEventHandler" msprop:Generator_TableClassName="stUROperDataTable" msprop:Generator_TableVarName="tablestUROper" msprop:Generator_RowDeletingName="stUROperRowDeleting" msprop:Generator_TablePropName="stUROper">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UROperID" msprop:Generator_UserColumnName="UROperID" msprop:Generator_ColumnVarNameInTable="columnUROperID" msprop:Generator_ColumnPropNameInRow="UROperID" msprop:Generator_ColumnPropNameInTable="UROperIDColumn" type="xs:int" />
              <xs:element name="URolesID" msprop:Generator_UserColumnName="URolesID" msprop:Generator_ColumnVarNameInTable="columnURolesID" msprop:Generator_ColumnPropNameInRow="URolesID" msprop:Generator_ColumnPropNameInTable="URolesIDColumn" type="xs:int" />
              <xs:element name="OperID" msprop:Generator_UserColumnName="OperID" msprop:Generator_ColumnVarNameInTable="columnOperID" msprop:Generator_ColumnPropNameInRow="OperID" msprop:Generator_ColumnPropNameInTable="OperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stUserActions" msprop:Generator_UserTableName="stUserActions" msprop:Generator_RowDeletedName="stUserActionsRowDeleted" msprop:Generator_RowChangedName="stUserActionsRowChanged" msprop:Generator_RowClassName="stUserActionsRow" msprop:Generator_RowChangingName="stUserActionsRowChanging" msprop:Generator_RowEvArgName="stUserActionsRowChangeEvent" msprop:Generator_RowEvHandlerName="stUserActionsRowChangeEventHandler" msprop:Generator_TableClassName="stUserActionsDataTable" msprop:Generator_TableVarName="tablestUserActions" msprop:Generator_RowDeletingName="stUserActionsRowDeleting" msprop:Generator_TablePropName="stUserActions">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserActionID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="UserActionID" msprop:Generator_ColumnVarNameInTable="columnUserActionID" msprop:Generator_ColumnPropNameInRow="UserActionID" msprop:Generator_ColumnPropNameInTable="UserActionIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="ActionsID" msprop:Generator_UserColumnName="ActionsID" msprop:Generator_ColumnVarNameInTable="columnActionsID" msprop:Generator_ColumnPropNameInRow="ActionsID" msprop:Generator_ColumnPropNameInTable="ActionsIDColumn" type="xs:int" />
              <xs:element name="Spend" msprop:Generator_UserColumnName="Spend" msprop:Generator_ColumnVarNameInTable="columnSpend" msprop:Generator_ColumnPropNameInRow="Spend" msprop:Generator_ColumnPropNameInTable="SpendColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stUserOper" msprop:Generator_UserTableName="stUserOper" msprop:Generator_RowDeletedName="stUserOperRowDeleted" msprop:Generator_RowChangedName="stUserOperRowChanged" msprop:Generator_RowClassName="stUserOperRow" msprop:Generator_RowChangingName="stUserOperRowChanging" msprop:Generator_RowEvArgName="stUserOperRowChangeEvent" msprop:Generator_RowEvHandlerName="stUserOperRowChangeEventHandler" msprop:Generator_TableClassName="stUserOperDataTable" msprop:Generator_TableVarName="tablestUserOper" msprop:Generator_RowDeletingName="stUserOperRowDeleting" msprop:Generator_TablePropName="stUserOper">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserOperID" msprop:Generator_UserColumnName="UserOperID" msprop:Generator_ColumnVarNameInTable="columnUserOperID" msprop:Generator_ColumnPropNameInRow="UserOperID" msprop:Generator_ColumnPropNameInTable="UserOperIDColumn" type="xs:int" />
              <xs:element name="UserID" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="OperID" msprop:Generator_UserColumnName="OperID" msprop:Generator_ColumnVarNameInTable="columnOperID" msprop:Generator_ColumnPropNameInRow="OperID" msprop:Generator_ColumnPropNameInTable="OperIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="3" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Spend" msprop:Generator_UserColumnName="Spend" msprop:Generator_ColumnVarNameInTable="columnSpend" msprop:Generator_ColumnPropNameInRow="Spend" msprop:Generator_ColumnPropNameInTable="SpendColumn" type="xs:boolean" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="stUsers" msprop:Generator_UserTableName="stUsers" msprop:Generator_RowDeletedName="stUsersRowDeleted" msprop:Generator_RowChangedName="stUsersRowChanged" msprop:Generator_RowClassName="stUsersRow" msprop:Generator_RowChangingName="stUsersRowChanging" msprop:Generator_RowEvArgName="stUsersRowChangeEvent" msprop:Generator_RowEvHandlerName="stUsersRowChangeEventHandler" msprop:Generator_TableClassName="stUsersDataTable" msprop:Generator_TableVarName="tablestUsers" msprop:Generator_RowDeletingName="stUsersRowDeleting" msprop:Generator_TablePropName="stUsers">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="UserID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="UserID" msprop:Generator_ColumnVarNameInTable="columnUserID" msprop:Generator_ColumnPropNameInRow="UserID" msprop:Generator_ColumnPropNameInTable="UserIDColumn" type="xs:int" />
              <xs:element name="StaffID" msprop:Generator_UserColumnName="StaffID" msprop:Generator_ColumnVarNameInTable="columnStaffID" msprop:Generator_ColumnPropNameInRow="StaffID" msprop:Generator_ColumnPropNameInTable="StaffIDColumn" type="xs:int" />
              <xs:element name="UserN" msprop:Generator_UserColumnName="UserN" msprop:Generator_ColumnVarNameInTable="columnUserN" msprop:Generator_ColumnPropNameInRow="UserN" msprop:Generator_ColumnPropNameInTable="UserNColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_UserColumnName="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Spend" msprop:Generator_UserColumnName="Spend" msprop:Generator_ColumnVarNameInTable="columnSpend" msprop:Generator_ColumnPropNameInRow="Spend" msprop:Generator_ColumnPropNameInTable="SpendColumn" type="xs:boolean" default="false" />
              <xs:element name="DateES" msprop:Generator_UserColumnName="DateES" msprop:Generator_ColumnVarNameInTable="columnDateES" msprop:Generator_ColumnPropNameInRow="DateES" msprop:Generator_ColumnPropNameInTable="DateESColumn" type="xs:anyType" minOccurs="0" />
              <xs:element name="DateEE" msprop:Generator_UserColumnName="DateEE" msprop:Generator_ColumnVarNameInTable="columnDateEE" msprop:Generator_ColumnPropNameInRow="DateEE" msprop:Generator_ColumnPropNameInTable="DateEEColumn" type="xs:anyType" minOccurs="0" />
              <xs:element name="DateSS" msprop:Generator_UserColumnName="DateSS" msprop:Generator_ColumnVarNameInTable="columnDateSS" msprop:Generator_ColumnPropNameInRow="DateSS" msprop:Generator_ColumnPropNameInTable="DateSSColumn" type="xs:anyType" minOccurs="0" />
              <xs:element name="DateSE" msprop:Generator_UserColumnName="DateSE" msprop:Generator_ColumnVarNameInTable="columnDateSE" msprop:Generator_ColumnPropNameInRow="DateSE" msprop:Generator_ColumnPropNameInTable="DateSEColumn" type="xs:anyType" minOccurs="0" />
              <xs:element name="Psw" msprop:Generator_UserColumnName="Psw" msprop:Generator_ColumnVarNameInTable="columnPsw" msprop:Generator_ColumnPropNameInRow="Psw" msprop:Generator_ColumnPropNameInTable="PswColumn" type="xs:base64Binary" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Attach" msdata:CaseSensitive="False" msprop:Generator_UserTableName="Attach" msprop:Generator_RowDeletedName="AttachRowDeleted" msprop:Generator_RowChangedName="AttachRowChanged" msprop:Generator_RowClassName="AttachRow" msprop:Generator_RowChangingName="AttachRowChanging" msprop:Generator_RowEvArgName="AttachRowChangeEvent" msprop:Generator_RowEvHandlerName="AttachRowChangeEventHandler" msprop:Generator_TableClassName="AttachDataTable" msprop:Generator_TableVarName="tableAttach" msprop:Generator_RowDeletingName="AttachRowDeleting" msprop:Generator_TablePropName="Attach">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msprop:Generator_UserColumnName="ID" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" type="xs:unsignedShort" />
              <xs:element name="isGrant" msprop:Generator_UserColumnName="isGrant" msprop:Generator_ColumnVarNameInTable="columnisGrant" msprop:Generator_ColumnPropNameInRow="isGrant" msprop:Generator_ColumnPropNameInTable="isGrantColumn" type="xs:short" />
              <xs:element name="BindID" msprop:Generator_UserColumnName="BindID" msprop:Generator_ColumnVarNameInTable="columnBindID" msprop:Generator_ColumnPropNameInRow="BindID" msprop:Generator_ColumnPropNameInTable="BindIDColumn" type="xs:short" minOccurs="0" />
              <xs:element name="CodeOp" msprop:Generator_UserColumnName="CodeOp" msprop:Generator_ColumnVarNameInTable="columnCodeOp" msprop:Generator_ColumnPropNameInRow="CodeOp" msprop:Generator_ColumnPropNameInTable="CodeOpColumn" type="xs:short" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fn_TGetActions1" msprop:Generator_UserTableName="fn_TGetActions1" msprop:Generator_RowDeletedName="fn_TGetActions1RowDeleted" msprop:Generator_RowChangedName="fn_TGetActions1RowChanged" msprop:Generator_RowClassName="fn_TGetActions1Row" msprop:Generator_RowChangingName="fn_TGetActions1RowChanging" msprop:Generator_RowEvArgName="fn_TGetActions1RowChangeEvent" msprop:Generator_RowEvHandlerName="fn_TGetActions1RowChangeEventHandler" msprop:Generator_TableClassName="fn_TGetActions1DataTable" msprop:Generator_TableVarName="tablefn_TGetActions1" msprop:Generator_RowDeletingName="fn_TGetActions1RowDeleting" msprop:Generator_TablePropName="fn_TGetActions1">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CodeID" msprop:Generator_UserColumnName="CodeID" msprop:Generator_ColumnPropNameInRow="CodeID" msprop:Generator_ColumnVarNameInTable="columnCodeID" msprop:Generator_ColumnPropNameInTable="CodeIDColumn" type="xs:int" />
              <xs:element name="hName" msprop:Generator_UserColumnName="hName" msprop:Generator_ColumnPropNameInRow="hName" msprop:Generator_ColumnVarNameInTable="columnhName" msprop:Generator_ColumnPropNameInTable="hNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="mgrid" msprop:Generator_UserColumnName="mgrid" msprop:Generator_ColumnPropNameInRow="mgrid" msprop:Generator_ColumnVarNameInTable="columnmgrid" msprop:Generator_ColumnPropNameInTable="mgridColumn" type="xs:int" minOccurs="0" />
              <xs:element name="hrclvl" msprop:Generator_UserColumnName="hrclvl" msprop:Generator_ColumnPropNameInRow="hrclvl" msprop:Generator_ColumnVarNameInTable="columnhrclvl" msprop:Generator_ColumnPropNameInTable="hrclvlColumn" type="xs:short" minOccurs="0" />
              <xs:element name="hrccrt" msprop:Generator_UserColumnName="hrccrt" msprop:Generator_ColumnPropNameInRow="hrccrt" msprop:Generator_ColumnVarNameInTable="columnhrccrt" msprop:Generator_ColumnPropNameInTable="hrccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="120" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hCode" msprop:Generator_UserColumnName="hCode" msprop:Generator_ColumnPropNameInRow="hCode" msprop:Generator_ColumnVarNameInTable="columnhCode" msprop:Generator_ColumnPropNameInTable="hCodeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="hccrt" msprop:Generator_UserColumnName="hccrt" msprop:Generator_ColumnPropNameInRow="hccrt" msprop:Generator_ColumnVarNameInTable="columnhccrt" msprop:Generator_ColumnPropNameInTable="hccrtColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="isGrant" msprop:Generator_UserColumnName="isGrant" msprop:Generator_ColumnPropNameInRow="isGrant" msprop:Generator_ColumnVarNameInTable="columnisGrant" msprop:Generator_ColumnPropNameInTable="isGrantColumn" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="dtStaff" msprop:Generator_UserTableName="dtStaff" msprop:Generator_RowDeletedName="dtStaffRowDeleted" msprop:Generator_RowChangedName="dtStaffRowChanged" msprop:Generator_RowClassName="dtStaffRow" msprop:Generator_RowChangingName="dtStaffRowChanging" msprop:Generator_RowEvArgName="dtStaffRowChangeEvent" msprop:Generator_RowEvHandlerName="dtStaffRowChangeEventHandler" msprop:Generator_TableClassName="dtStaffDataTable" msprop:Generator_TableVarName="tabledtStaff" msprop:Generator_RowDeletingName="dtStaffRowDeleting" msprop:Generator_TablePropName="dtStaff">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="StaffID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="StaffID" msprop:Generator_ColumnVarNameInTable="columnStaffID" msprop:Generator_ColumnPropNameInRow="StaffID" msprop:Generator_ColumnPropNameInTable="StaffIDColumn" type="xs:int" />
              <xs:element name="DepID" msprop:Generator_UserColumnName="DepID" msprop:Generator_ColumnVarNameInTable="columnDepID" msprop:Generator_ColumnPropNameInRow="DepID" msprop:Generator_ColumnPropNameInTable="DepIDColumn" type="xs:int" />
              <xs:element name="PostID" msprop:Generator_UserColumnName="PostID" msprop:Generator_ColumnVarNameInTable="columnPostID" msprop:Generator_ColumnPropNameInRow="PostID" msprop:Generator_ColumnPropNameInTable="PostIDColumn" type="xs:int" />
              <xs:element name="CityID" msprop:Generator_UserColumnName="CityID" msprop:Generator_ColumnVarNameInTable="columnCityID" msprop:Generator_ColumnPropNameInRow="CityID" msprop:Generator_ColumnPropNameInTable="CityIDColumn" type="xs:int" />
              <xs:element name="StaffName" msprop:Generator_UserColumnName="StaffName" msprop:Generator_ColumnVarNameInTable="columnStaffName" msprop:Generator_ColumnPropNameInRow="StaffName" msprop:Generator_ColumnPropNameInTable="StaffNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="addr" msprop:Generator_UserColumnName="addr" msprop:Generator_ColumnVarNameInTable="columnaddr" msprop:Generator_ColumnPropNameInRow="addr" msprop:Generator_ColumnPropNameInTable="addrColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Gender" msprop:Generator_UserColumnName="Gender" msprop:Generator_ColumnVarNameInTable="columnGender" msprop:Generator_ColumnPropNameInRow="Gender" msprop:Generator_ColumnPropNameInTable="GenderColumn" type="xs:boolean" default="true" minOccurs="0" />
              <xs:element name="DBorn" msprop:Generator_UserColumnName="DBorn" msprop:Generator_ColumnVarNameInTable="columnDBorn" msprop:Generator_ColumnPropNameInRow="DBorn" msprop:Generator_ColumnPropNameInTable="DBornColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DWork" msprop:Generator_UserColumnName="DWork" msprop:Generator_ColumnVarNameInTable="columnDWork" msprop:Generator_ColumnPropNameInRow="DWork" msprop:Generator_ColumnPropNameInTable="DWorkColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PerNum" msprop:Generator_UserColumnName="PerNum" msprop:Generator_ColumnVarNameInTable="columnPerNum" msprop:Generator_ColumnPropNameInRow="PerNum" msprop:Generator_ColumnPropNameInTable="PerNumColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="12" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TabNum" msprop:Generator_UserColumnName="TabNum" msprop:Generator_ColumnVarNameInTable="columnTabNum" msprop:Generator_ColumnPropNameInRow="TabNum" msprop:Generator_ColumnPropNameInTable="TabNumColumn" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//dtCity" />
      <xs:field xpath="CodeID" />
    </xs:unique>
    <xs:unique name="dtDep_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//dtDep" />
      <xs:field xpath="CodeID" />
    </xs:unique>
    <xs:unique name="dtPost_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//dtPost" />
      <xs:field xpath="CodeID" />
    </xs:unique>
    <xs:unique name="stAccess_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stAccess" />
      <xs:field xpath="AccessID" />
    </xs:unique>
    <xs:unique name="stActions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stActions" />
      <xs:field xpath="CodeID" />
    </xs:unique>
    <xs:unique name="stRoles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stRoles" />
      <xs:field xpath="RolesID" />
    </xs:unique>
    <xs:unique name="stURoles_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stURoles" />
      <xs:field xpath="URolesID" />
    </xs:unique>
    <xs:unique name="stUROper_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stUROper" />
      <xs:field xpath="UROperID" />
    </xs:unique>
    <xs:unique name="stUserActions_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stUserActions" />
      <xs:field xpath="UserActionID" />
    </xs:unique>
    <xs:unique name="stUserOper_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stUserOper" />
      <xs:field xpath="UserOperID" />
    </xs:unique>
    <xs:unique name="stUsers_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//stUsers" />
      <xs:field xpath="UserID" />
    </xs:unique>
    <xs:unique name="fn_TGetActions1Key1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//fn_TGetActions1" />
      <xs:field xpath="CodeID" />
    </xs:unique>
    <xs:unique name="dtStaff_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//dtStaff" />
      <xs:field xpath="StaffID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_dtCity_dtCity" msdata:parent="dtCity" msdata:child="dtCity" msdata:parentkey="CodeID" msdata:childkey="mgrid" msprop:Generator_UserRelationName="FK_dtCity_dtCity" msprop:Generator_RelationVarName="relationFK_dtCity_dtCity" msprop:Generator_UserChildTable="dtCity" msprop:Generator_UserParentTable="dtCity" msprop:Generator_ParentPropName="dtCityRowParent" msprop:Generator_ChildPropName="GetdtCityRows" />
      <msdata:Relationship name="FK_dtDep_dtDep" msdata:parent="dtDep" msdata:child="dtDep" msdata:parentkey="CodeID" msdata:childkey="mgrid" msprop:Generator_UserRelationName="FK_dtDep_dtDep" msprop:Generator_RelationVarName="relationFK_dtDep_dtDep" msprop:Generator_UserChildTable="dtDep" msprop:Generator_UserParentTable="dtDep" msprop:Generator_ParentPropName="dtDepRowParent" msprop:Generator_ChildPropName="GetdtDepRows" />
      <msdata:Relationship name="FK_dtPost_dtPost" msdata:parent="dtPost" msdata:child="dtPost" msdata:parentkey="CodeID" msdata:childkey="mgrid" msprop:Generator_UserRelationName="FK_dtPost_dtPost" msprop:Generator_RelationVarName="relationFK_dtPost_dtPost" msprop:Generator_UserChildTable="dtPost" msprop:Generator_UserParentTable="dtPost" msprop:Generator_ParentPropName="dtPostRowParent" msprop:Generator_ChildPropName="GetdtPostRows" />
      <msdata:Relationship name="FK_stAccess_stURoles" msdata:parent="stURoles" msdata:child="stAccess" msdata:parentkey="URolesID" msdata:childkey="URolesID" msprop:Generator_UserRelationName="FK_stAccess_stURoles" msprop:Generator_RelationVarName="relationFK_stAccess_stURoles" msprop:Generator_UserChildTable="stAccess" msprop:Generator_UserParentTable="stURoles" msprop:Generator_ParentPropName="stURolesRow" msprop:Generator_ChildPropName="GetstAccessRows" />
      <msdata:Relationship name="FK_stURoles_stRoles" msdata:parent="stRoles" msdata:child="stURoles" msdata:parentkey="RolesID" msdata:childkey="RolesID" msprop:Generator_UserRelationName="FK_stURoles_stRoles" msprop:Generator_RelationVarName="relationFK_stURoles_stRoles" msprop:Generator_UserChildTable="stURoles" msprop:Generator_UserParentTable="stRoles" msprop:Generator_ParentPropName="stRolesRow" msprop:Generator_ChildPropName="GetstURolesRows" />
      <msdata:Relationship name="FK_stURoles_stUsers" msdata:parent="stUsers" msdata:child="stURoles" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_stURoles_stUsers" msprop:Generator_RelationVarName="relationFK_stURoles_stUsers" msprop:Generator_UserChildTable="stURoles" msprop:Generator_UserParentTable="stUsers" msprop:Generator_ParentPropName="stUsersRow" msprop:Generator_ChildPropName="GetstURolesRows" />
      <msdata:Relationship name="FK_stUROper_stURoles" msdata:parent="stURoles" msdata:child="stUROper" msdata:parentkey="URolesID" msdata:childkey="URolesID" msprop:Generator_UserRelationName="FK_stUROper_stURoles" msprop:Generator_RelationVarName="relationFK_stUROper_stURoles" msprop:Generator_UserChildTable="stUROper" msprop:Generator_UserParentTable="stURoles" msprop:Generator_ParentPropName="stURolesRow" msprop:Generator_ChildPropName="GetstUROperRows" />
      <msdata:Relationship name="FK_stUserActions_stUsers" msdata:parent="stUsers" msdata:child="stUserActions" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_stUserActions_stUsers" msprop:Generator_RelationVarName="relationFK_stUserActions_stUsers" msprop:Generator_UserChildTable="stUserActions" msprop:Generator_UserParentTable="stUsers" msprop:Generator_ParentPropName="stUsersRow" msprop:Generator_ChildPropName="GetstUserActionsRows" />
      <msdata:Relationship name="FK_stUserOper_stUsers" msdata:parent="stUsers" msdata:child="stUserOper" msdata:parentkey="UserID" msdata:childkey="UserID" msprop:Generator_UserRelationName="FK_stUserOper_stUsers" msprop:Generator_RelationVarName="relationFK_stUserOper_stUsers" msprop:Generator_UserChildTable="stUserOper" msprop:Generator_UserParentTable="stUsers" msprop:Generator_ParentPropName="stUsersRow" msprop:Generator_ChildPropName="GetstUserOperRows" />
      <msdata:Relationship name="FK_stAccess_stActions" msdata:parent="stActions" msdata:child="stAccess" msdata:parentkey="CodeID" msdata:childkey="ActionsID" msprop:Generator_UserRelationName="FK_stAccess_stActions" msprop:Generator_RelationVarName="relationFK_stAccess_stActions" msprop:Generator_UserChildTable="stAccess" msprop:Generator_UserParentTable="stActions" msprop:Generator_ParentPropName="stActionsRow" msprop:Generator_ChildPropName="GetstAccessRows" />
      <msdata:Relationship name="FK_stActions_stActions" msdata:parent="stActions" msdata:child="stActions" msdata:parentkey="CodeID" msdata:childkey="mgrid" msprop:Generator_UserRelationName="FK_stActions_stActions" msprop:Generator_RelationVarName="relationFK_stActions_stActions" msprop:Generator_UserChildTable="stActions" msprop:Generator_UserParentTable="stActions" msprop:Generator_ParentPropName="stActionsRowParent" msprop:Generator_ChildPropName="GetstActionsRows" />
      <msdata:Relationship name="FK_stUserActions_stActions" msdata:parent="stActions" msdata:child="stUserActions" msdata:parentkey="CodeID" msdata:childkey="ActionsID" msprop:Generator_UserRelationName="FK_stUserActions_stActions" msprop:Generator_RelationVarName="relationFK_stUserActions_stActions" msprop:Generator_UserChildTable="stUserActions" msprop:Generator_UserParentTable="stActions" msprop:Generator_ParentPropName="stActionsRow" msprop:Generator_ChildPropName="GetstUserActionsRows" />
      <msdata:Relationship name="fn_TGetActions1_fn_TGetActions1" msdata:parent="fn_TGetActions1" msdata:child="fn_TGetActions1" msdata:parentkey="CodeID" msdata:childkey="mgrid" msprop:Generator_UserRelationName="fn_TGetActions1_fn_TGetActions1" msprop:Generator_RelationVarName="relationfn_TGetActions1_fn_TGetActions1" msprop:Generator_UserChildTable="fn_TGetActions1" msprop:Generator_UserParentTable="fn_TGetActions1" msprop:Generator_ParentPropName="fn_TGetActions1RowParent" msprop:Generator_ChildPropName="Getfn_TGetActions1Rows" />
      <msdata:Relationship name="FK_stUsers_dtStaff1" msdata:parent="dtStaff" msdata:child="stUsers" msdata:parentkey="StaffID" msdata:childkey="StaffID" msprop:Generator_UserRelationName="FK_stUsers_dtStaff1" msprop:Generator_RelationVarName="relationFK_stUsers_dtStaff1" msprop:Generator_UserChildTable="stUsers" msprop:Generator_UserParentTable="dtStaff" msprop:Generator_ParentPropName="dtStaffRow" msprop:Generator_ChildPropName="GetstUsersRows" />
      <msdata:Relationship name="FK_dtStaff_dtCity" msdata:parent="dtCity" msdata:child="dtStaff" msdata:parentkey="CodeID" msdata:childkey="CityID" msprop:Generator_UserRelationName="FK_dtStaff_dtCity" msprop:Generator_RelationVarName="relationFK_dtStaff_dtCity" msprop:Generator_UserChildTable="dtStaff" msprop:Generator_UserParentTable="dtCity" msprop:Generator_ParentPropName="dtCityRow" msprop:Generator_ChildPropName="GetdtStaffRows" />
      <msdata:Relationship name="FK_dtStaff_dtDep1" msdata:parent="dtDep" msdata:child="dtStaff" msdata:parentkey="CodeID" msdata:childkey="DepID" msprop:Generator_UserRelationName="FK_dtStaff_dtDep1" msprop:Generator_RelationVarName="relationFK_dtStaff_dtDep1" msprop:Generator_UserChildTable="dtStaff" msprop:Generator_UserParentTable="dtDep" msprop:Generator_ParentPropName="dtDepRow" msprop:Generator_ChildPropName="GetdtStaffRows" />
      <msdata:Relationship name="FK_dtStaff_dtPost1" msdata:parent="dtPost" msdata:child="dtStaff" msdata:parentkey="CodeID" msdata:childkey="PostID" msprop:Generator_UserRelationName="FK_dtStaff_dtPost1" msprop:Generator_RelationVarName="relationFK_dtStaff_dtPost1" msprop:Generator_UserChildTable="dtStaff" msprop:Generator_UserParentTable="dtPost" msprop:Generator_ParentPropName="dtPostRow" msprop:Generator_ChildPropName="GetdtStaffRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>